ERROR CODE - Mailing list pgsql-general

From Ray Alba
Subject ERROR CODE
Date
Msg-id v03007802b53081fc313a@[208.37.244.165]
Whole thread Raw
Responses Re: ERROR CODE  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
I am creating a new table called patienttype with categories -
infant,pediatric, adult in the doctors table

for some reason it allows me to create a sequence but, when I create a
table that requires that sequence, I get the following.

create table patienttype (
id INT DEFAULT nextval ('category_seq'),
parent id INT DEFAULT '0',
type varchar(50));

Here is the error? What is that all about?
ERROR:  Unable to locate type name 'id' in catalog

Thanks,

Ray

    ---------------------------------
    *         ***        *
    *  Ray Alba/ dotsperinch        *
    *   74 Varick  |  55 W 92nd St. *
    * 212.966.4979 | 212.864.6456   *
    * Fax.966.3866 | 212.864.4489   *
    *    ralba@dotsperinch.com    *
        *  http://www.dotsperinch.com   *
    *  http://www.dotsperinch.com    *
    ---------------------------------



pgsql-general by date:

Previous
From: "Marcel Sierra"
Date:
Subject: Objective : 1st. aplication with Tcl/Tk and Postgres
Next
From: Lukasz Michalski
Date:
Subject: creating temp table...